<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="elibrary.DesEncrypter"%>
<%@ page import="elibrary.DaoConnection" %>
<%@ page language="java" import="java.util.*"%>
<%@ include file="config.jsp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>My-Library | Add Books</title>
        <meta name="keywords" content="My Library" />
        <meta name="description" content="Library" />
        <link href="css/style.css" rel="stylesheet" type="text/css" />
        <link href="css/jquery.ennui.contentslider.css" rel="stylesheet" type="text/css" media="screen,projection" />
        <script language="javascript" type="text/javascript">



            function clearText(field)
            {
                if (field.defaultValue == field.value) field.value = '';
                else if (field.value == '') field.value = field.defaultValue;
            }
        </script>
    </head>
    <body>

        <%

        //getting the username and password from the session

        String username=request.getParameter("username");
        String password=request.getParameter("password");

        Statement stmt = null;
        ResultSet results = null;

        //Connection is made to the database

        try{
                Connection c=DaoConnection.getcon(connectURL, DBuser, DBpass);
                 Statement st=c.createStatement();
                    ResultSet rs=st.executeQuery("SELECT * FROM USERBOOKINFO");


	
 
        %>





        <div id="templatemo_header_wrapper">

            <div id="templatemo_header">

                <div id="site_logo"><img src="images/logo.jpeg" width="100" height="100"></div><div align="left"><img src="images/header.png"></div>
            </div> <!-- end of header -->
        </div> <!-- end of header wrapper -->

        <div id="templatemo_menu_wrapper">

            <div id="templatemo_menu">
                <ul>
                    <li><a href="#" class="current">Home</a></li>
                    <li><a href="#">Web Design</a></li>
                    <li><a href="http://www.templatemo.com" target="_parent">Templates</a></li>
                    <li><a href="#">About</a></li>
                    <li><a href="#" class="last">Contact Us</a></li>
                </ul>
            </div> <!-- end of menu -->
        </div> <!-- end of menu wrapper -->

        <div id="tempatemo_content_wrapper">

            <div id="templatemo_content">

                <div class="content_top">

                </div>

                <div id="content_panel">

                    <div id="column_w610">

                        <div class="header_01">Welcome .........</div>
                        <div class="header_05"> <i>No. of books issued </i> :....</div>
                        <br>
                            <div class="section_01">
                                <table class="tab1" border=1>
                                    <tr><td align="center">Book id</td><td align="center">Book Name</td><td align="center">Issue Date</td><td align="center">Due Date</td></tr>
                                    <%while(rs.next())
                             {
     
                                    %>


                                    <tr><td align="center"><%=rs.getString(1)%>&nbsp</td><td align="center"><%=rs.getString(2)%>&nbsp</td><td align="center"><%=rs.getTimestamp(3)%>&nbsp</td><td align="center"><%=rs.getDate(4)%>&nbsp</td></tr><%}}catch(Exception e){out.println(e);} %>
                                </table>
                                <div class="bottom"></div>
                            </div>

                            <p></p>

                            <ul class="list_with_icon">
                                <li></li>
                                <li>Last Login : ...............</li>
                            </ul>

                    </div> <!-- end of column w610 -->

                    <div id="column_w290">

                        <div class="header_02">Choose from here</div>

                        <div class="choose_options">
                            <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">
                            </div>
                            <div class="opt_content">
                                <div class="header_05"><a href="#">See your account</a></div>
                            </div>

                            <div class="cleaner"></div>
                        </div>

                        <div class="choose_options">
                            <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">
                            </div>
                            <div class="opt_content">
                                <div class="header_05"><a href="#">Browse Books/Journals</a></div>
                            </div>

                            <div class="cleaner"></div>
                        </div>

                        <div class="choose_options">
                            <div class="opt_hand"><img src="images/hand.gif" height="35" width="50">
                            </div>
                            <div class="opt_content">
                                <div class="header_05"><a href="#">Make Requests for Books/Journals</a></div>
                            </div>

                            <div class="cleaner"></div>
                        </div>




                    </div> <!-- end of column 290 -->

                    <div class="cleaner"></div>

                </div> <!-- end of content panel -->

                <div class="cleaner"></div>
            </div> <!-- end of content -->

        </div> <!-- end of content wrapper -->

        <div id="templatemo_footer_wrapper">

            <div id="templatemo_footer">

                <center>Copyright &#169; 2010 MyLibrary &nbsp &nbsp | &nbsp &nbsp <a href="termsandconditions.jsp"><font color="#828c96"> Terms and Conditions</font></a> </center><br></br>
                <center><b>Disclaimer:</b> No Part of this site can be copied or reproduced in any form, excepting for personal information, without the written permission of the owners.</center>
            </div> <!-- end of footer -->
        </div> <!-- end of footer -->
    </body>
</html>
